Step-3 Add Azure Active Directory Credentials to Database
You must add the Azure Active Directory credentials generated in to Step 1- Run AudioCodes PowerShell Script to the Live Platform UMP-365 SQL database.
| ➢ | To add credentials to database: |
| 1. | Open the Microsoft SQL Server Management Studio. |
| 2. | Connect using the following credentials: |
|
Parameter |
Description |
|---|---|
|
Server type |
Database Engine |
|
Server name |
[servername]\SQLSYSADMIN |
|
Authentication |
Windows Authentication |
| 3. | In the Navigation pane, select Databases > SysAdminTenant > dbo.ApplicationSetting, right-click and then choose Edit Top 200 Rows. |
| 4. | Set the rows described in the table below. |
|
Id |
Value |
|---|---|
| AzureAdJwt.ClientId | 9d576dc4-b85d-4571-880e-4c6ed4c08c31 |
| AzureAdJwt.Domain | audiocodessaas.onmicrosoft.com |
| AzureAdJwt.TenantId | 36bc587e-514a-465c-ae90-2c7b99535f8f |
| AzureAdJwt.ValidIssuers | "https://sts.windows.net/ <ServiceProviderAzureTenantID>"] where <ServiceProviderAzureTenantID> is the Direc tory (tenant) ID shown in the figure above. |
| 5. | Restart the UMP-365 IIS service. |
| 6. | Proceed to Step-4 Configure REST API Client. |